python连接mysql

example

#coding=UTF-8

import sys
import MySQLdb
import time

reload(sys)
sys.setdefaultencoding('utf-8')

def connectDemo():
    return MySQLdb.Connection("127.0.0.1","root","root","demo",3306,charset="utf8")


if __name__ == '__main__':
    begin=time.time()

    conn=connectDemo()
    cursor = conn.cursor()
    sql="""
        show tables
        """
    count = cursor.execute(sql)
    rows = cursor.fetchall()
    cursor.close()
    conn.close()
    print "========demo库共:%s 张表============" % (count)

    print '耗时:%s 秒' % (time.time()-begin)